package com.project.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.project.bean.EmployeeBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.util.List;

@Mapper
public interface IEmployeeMapper extends BaseMapper<EmployeeBean> {
    @Select("SELECT e.*,d.`d_name`  FROM t_employee e,t_dept d " +
            " WHERE e.`fk_deptId`=d.`pk_deptId`")
    @ResultMap("emMap")
    public List<EmployeeBean> findAll();

    public IPage<EmployeeBean> findByItem(Page pg,@Param("name") String name,
                                                  @Param("startDate") LocalDate startDate,
                                                  @Param("endDate") LocalDate endDate);
}
